#! /bin/bash
export LANG=zh_CN.UTF-8
HIVE_HOME=/usr/bin/hive

${HIVE_HOME} -S -e "
create table edu_dm.edu_dm_relationship_count
(
dt string,
year_code string,
year_month string,
time_type string,
group_type_new string,
group_type_old string,
origin_type string,
clue_state string,
area string,
subject_name string,
school_name string,
origin_channel string,
apartment_name string,
nums_count bigint
)
row format delimited fields terminated by '\t'
stored as orc tblproperties ('orc.compress' = 'SNAPPY');
"